<?php
#
# author: Cody Sorgenfrey
# (c)2012 South Hill Calvary Chapel
#

include_once("../mysql/database_info.php");
include_once("common.php");
include_once("../mysql/common.php");

$title = "Contacts"; 
$meta_key= 'contact, information, phone, e-mail, fax, email, call, address, reach, church';
$meta_desc= "The contact information for South Hill Calvary Chapel in Puyallup, WA.";
$morehtml= NULL;
$morejava= NULL;

startPage($title, $meta_key, $meta_desc, $morehtml, $morejava);
?>

<table style='width:100%'>
	<tr>
		<td><h4>SHCC Office</h4></td>
		<td><h4>Pastor On Call</h4></td>
	</tr>
	<tr>
		<td class='contacts'><p style="margin-top:-20px;">
				1902 South Meridian<br>
				Puyallup, WA 98371<br><br>

				Phone: 253.841.5680<br>
				Fax: 253.841.5672<br>
				Email: <a href='mailto:mail@southhillcalvary.org'>[mail@southhillcalvary.org]</a></p></td>
		
		<td class="contacts"><p style="margin-top:-20px;">
			After hours prayer and support<br>
			Phone: 253.841.5680 ext 2<br>
			
			<a href="http://eepurl.com/svnwz"><h4 style="font-size:130%;">[Join our Emailing List]</h4></a>
			</p></td>
	</tr>
</table>
<br><br>

<?
$table = "people";

connect_select_test($table);

$query="SELECT * FROM $table WHERE leader='1' or staff='1' ORDER BY display_order ASC";

$result=mysql_query($query) or die (mysql_error());

$num_rows=mysql_num_rows($result);

mContact_table($result, $num_rows, "Church Leadership and Staff");

mysql_close();


$table = "contact_ministry";

connect_select_test($table);

$query="SELECT * FROM $table ORDER BY position ASC";

$result=mysql_query($query) or die (mysql_error());

$num_rows=mysql_num_rows($result);

mContact_table($result, $num_rows, "Ministry Contacts");

mysql_close();

endPage();
?>